<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/7/3
 * Time: 18:38
 */
namespace app\common\help;

class CustomerHelp {

    /**
     * 订单数据导入excel的表头对应关系
     */
    public static function customerDataExcelHeader()
    {
        return [
            'A' => 'company_name',
            'B' => 'short_name',
            'C' => 'taxpayer_identity_numbe',
            'D' => 'province',
            'E' => 'city',
            'F' => 'district',
            'G' => 'address',
            'H' => 'legal_person',
            'I' => 'revenue',
            'J' => 'star_level',
            'K' => 'business_scope',
            'L' => 'financial_software',
            'M' => 'is_general_taxpayer',
            'N' => 'tax_discount',
            'O' => 'tax_bureau',
            'P' => 'tax_bureau_manager',
            'Q' => 'tax_bureau_manager_tel',
            'R' => 'tax_bureau_manager_qq',
            'S' => 'tax_bureau_manager_wx',
            'T' => 'tax_bureau_manager_email',
            'U' => 'financial_deputy_majordomo',
            'V' => 'financial_deputy_majordomo_tel',
            'W' => 'financial_deputy_majordomo_qq',
            'X' => 'financial_deputy_majordomo_wx',
            'Y' => 'financial_deputy_majordomo_email',
            'Z' => 'financial_deputy_manager',
            'AA' => 'financial_deputy_manager_tel',
            'AB' => 'financial_deputy_manager_qq',
            'AC' => 'financial_deputy_manager_wx',
            'AD' => 'financial_deputy_manager_email',
            'AE' => 'accountant_leader',
            'AF' => 'accountant_leader_tel',
            'AG' => 'accountant_leader_qq',
            'AH' => 'accountant_leader_wx',
            'AI' => 'accountant_leader_email',
            'AJ' => 'note',
        ];
    }
}